Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 322047 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 51.9 MiB |
| Average record size in memory | 169.0 B |
Variable types
| Numeric | 9 |
|---|---|
| DateTime | 1 |
| Categorical | 9 |
| Text | 1 |
| Boolean | 1 |
city is highly overall correlated with state and 1 other fields | High correlation |
cluster is highly overall correlated with state and 1 other fields | High correlation |
day is highly overall correlated with locale_name | High correlation |
dcoilwtico is highly overall correlated with id and 1 other fields | High correlation |
id is highly overall correlated with dcoilwtico and 1 other fields | High correlation |
locale is highly overall correlated with locale_name | High correlation |
locale_name is highly overall correlated with day and 1 other fields | High correlation |
onpromotion is highly overall correlated with sales | High correlation |
sales is highly overall correlated with onpromotion | High correlation |
state is highly overall correlated with city and 2 other fields | High correlation |
store_nbr is highly overall correlated with type_of_store | High correlation |
type_of_store is highly overall correlated with city and 3 other fields | High correlation |
year is highly overall correlated with dcoilwtico and 1 other fields | High correlation |
transferred is highly imbalanced (74.6%) | Imbalance |
family is uniformly distributed | Uniform |
sales has 73481 (22.8%) zeros | Zeros |
onpromotion has 238596 (74.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-28 18:01:34.957119 |
|---|---|
| Analysis finished | 2024-02-28 18:03:32.192889 |
| Duration | 1 minute and 57.24 seconds |
| Software version | ydata-profiling vv4.6.5 |
| Download configuration | config.json |
id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 292545 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1682979.5 |
| Minimum | 561 |
|---|---|
| Maximum | 3000887 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 561 |
|---|---|
| 5-th percentile | 326484.3 |
| Q1 | 1010616.5 |
| median | 1842406 |
| Q3 | 2209555.5 |
| 95-th percentile | 2852916.7 |
| Maximum | 3000887 |
| Range | 3000326 |
| Interquartile range (IQR) | 1198939 |
Descriptive statistics
| Standard deviation | 786249.26 |
|---|---|
| Coefficient of variation (CV) | 0.46717698 |
| Kurtosis | -1.0200574 |
| Mean | 1682979.5 |
| Median Absolute Deviation (MAD) | 641223 |
| Skewness | -0.22757083 |
| Sum | 5.4199849 × 1011 |
| Variance | 6.181879 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 961254 | 4 | < 0.1% |
| 961469 | 4 | < 0.1% |
| 961819 | 4 | < 0.1% |
| 961818 | 4 | < 0.1% |
| 961821 | 4 | < 0.1% |
| 961834 | 4 | < 0.1% |
| 961835 | 4 | < 0.1% |
| 961837 | 4 | < 0.1% |
| 961836 | 4 | < 0.1% |
| 961850 | 4 | < 0.1% |
| Other values (292535) | 322007 |
| Value | Count | Frequency (%) |
| 561 | 1 | |
| 562 | 1 | |
| 563 | 1 | |
| 564 | 1 | |
| 565 | 1 | |
| 566 | 1 | |
| 567 | 1 | |
| 568 | 1 | |
| 569 | 1 | |
| 570 | 1 |
| Value | Count | Frequency (%) |
| 3000887 | 1 | |
| 3000886 | 1 | |
| 3000885 | 1 | |
| 3000884 | 1 | |
| 3000883 | 1 | |
| 3000882 | 1 | |
| 3000881 | 1 | |
| 3000880 | 1 | |
| 3000879 | 1 | |
| 3000878 | 1 |
date
Date
| Distinct | 179 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2017-08-15 00:00:00 |
Histogram with fixed size bins (bins=50)
store_nbr
Real number (ℝ)
HIGH CORRELATION
| Distinct | 54 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.994672 |
| Minimum | 1 |
|---|---|
| Maximum | 54 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 13 |
| median | 27 |
| Q3 | 40 |
| 95-th percentile | 51 |
| Maximum | 54 |
| Range | 53 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.595174 |
|---|---|
| Coefficient of variation (CV) | 0.57771305 |
| Kurtosis | -1.2291947 |
| Mean | 26.994672 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.003300613 |
| Sum | 8693553 |
| Variance | 243.20946 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 6402 | 2.0% |
| 10 | 6402 | 2.0% |
| 5 | 6402 | 2.0% |
| 33 | 6402 | 2.0% |
| 17 | 6402 | 2.0% |
| 41 | 6402 | 2.0% |
| 16 | 6402 | 2.0% |
| 15 | 6402 | 2.0% |
| 2 | 6402 | 2.0% |
| 11 | 6402 | 2.0% |
| Other values (44) | 258027 |
| Value | Count | Frequency (%) |
| 1 | 6402 | |
| 2 | 6402 | |
| 3 | 6402 | |
| 4 | 6402 | |
| 5 | 6402 | |
| 6 | 6402 | |
| 7 | 6402 | |
| 8 | 6402 | |
| 9 | 6402 | |
| 10 | 6402 |
| Value | Count | Frequency (%) |
| 54 | 6402 | |
| 53 | 5148 | |
| 52 | 429 | 0.1% |
| 51 | 6402 | |
| 50 | 6402 | |
| 49 | 6402 | |
| 48 | 6402 | |
| 47 | 6402 | |
| 46 | 6402 | |
| 45 | 6402 |
family
Categorical
UNIFORM
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| AUTOMOTIVE | 9759 |
|---|---|
| MAGAZINES | 9759 |
| LIQUOR,WINE,BEER | 9759 |
| LINGERIE | 9759 |
| LAWN AND GARDEN | 9759 |
| Other values (28) |
Length
| Max length | 26 |
|---|---|
| Median length | 16 |
| Mean length | 10.757576 |
| Min length | 4 |
Characters and Unicode
| Total characters | 3464445 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AUTOMOTIVE |
|---|---|
| 2nd row | MAGAZINES |
| 3rd row | LIQUOR,WINE,BEER |
| 4th row | LINGERIE |
| 5th row | LAWN AND GARDEN |
Common Values
| Value | Count | Frequency (%) |
| AUTOMOTIVE | 9759 | 3.0% |
| MAGAZINES | 9759 | 3.0% |
| LIQUOR,WINE,BEER | 9759 | 3.0% |
| LINGERIE | 9759 | 3.0% |
| LAWN AND GARDEN | 9759 | 3.0% |
| LADIESWEAR | 9759 | 3.0% |
| HOME CARE | 9759 | 3.0% |
| HOME APPLIANCES | 9759 | 3.0% |
| HOME AND KITCHEN II | 9759 | 3.0% |
| HOME AND KITCHEN I | 9759 | 3.0% |
| Other values (23) | 224457 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| and | 48795 | 9.1% |
| home | 39036 | 7.3% |
| care | 29277 | 5.5% |
| kitchen | 19518 | 3.6% |
| grocery | 19518 | 3.6% |
| foods | 19518 | 3.6% |
| supplies | 19518 | 3.6% |
| ii | 19518 | 3.6% |
| i | 19518 | 3.6% |
| baby | 9759 | 1.8% |
| Other values (30) | 292770 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 468432 | |
| A | 312288 | 9.0% |
| R | 263493 | 7.6% |
| O | 253734 | 7.3% |
| I | 234216 | 6.8% |
| 214698 | 6.2% | |
| N | 185421 | 5.4% |
| S | 175662 | 5.1% |
| D | 156144 | 4.5% |
| L | 146385 | 4.2% |
| Other values (17) | 1053972 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3220470 | |
| Space Separator | 214698 | 6.2% |
| Other Punctuation | 29277 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 468432 | |
| A | 312288 | 9.7% |
| R | 263493 | 8.2% |
| O | 253734 | 7.9% |
| I | 234216 | 7.3% |
| N | 185421 | 5.8% |
| S | 175662 | 5.5% |
| D | 156144 | 4.8% |
| L | 146385 | 4.5% |
| C | 146385 | 4.5% |
| Other values (14) | 878310 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 19518 | |
| / | 9759 |
Space Separator
| Value | Count | Frequency (%) |
| 214698 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3220470 | |
| Common | 243975 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 468432 | |
| A | 312288 | 9.7% |
| R | 263493 | 8.2% |
| O | 253734 | 7.9% |
| I | 234216 | 7.3% |
| N | 185421 | 5.8% |
| S | 175662 | 5.5% |
| D | 156144 | 4.8% |
| L | 146385 | 4.5% |
| C | 146385 | 4.5% |
| Other values (14) | 878310 |
Common
| Value | Count | Frequency (%) |
| 214698 | ||
| , | 19518 | 8.0% |
| / | 9759 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3464445 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 468432 | |
| A | 312288 | 9.0% |
| R | 263493 | 7.6% |
| O | 253734 | 7.3% |
| I | 234216 | 6.8% |
| 214698 | 6.2% | |
| N | 185421 | 5.4% |
| S | 175662 | 5.1% |
| D | 156144 | 4.5% |
| L | 146385 | 4.2% |
| Other values (17) | 1053972 |
sales
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 56108 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 406.38345 |
| Minimum | 0 |
|---|---|
| Maximum | 124717 |
| Zeros | 73481 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 19 |
| Q3 | 241.2605 |
| 95-th percentile | 2226.7978 |
| Maximum | 124717 |
| Range | 124717 |
| Interquartile range (IQR) | 240.2605 |
Descriptive statistics
| Standard deviation | 1246.8812 |
|---|---|
| Coefficient of variation (CV) | 3.0682382 |
| Kurtosis | 675.05566 |
| Mean | 406.38345 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | 13.376369 |
| Sum | 1.3087457 × 108 |
| Variance | 1554712.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 73481 | 22.8% |
| 1 | 14109 | 4.4% |
| 2 | 10532 | 3.3% |
| 3 | 8323 | 2.6% |
| 4 | 7086 | 2.2% |
| 5 | 6137 | 1.9% |
| 6 | 5500 | 1.7% |
| 7 | 4687 | 1.5% |
| 8 | 4065 | 1.3% |
| 9 | 3733 | 1.2% |
| Other values (56098) | 184394 |
| Value | Count | Frequency (%) |
| 0 | 73481 | |
| 0.188 | 1 | < 0.1% |
| 0.294 | 1 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| 0.33 | 1 | < 0.1% |
| 0.338 | 1 | < 0.1% |
| 0.396 | 1 | < 0.1% |
| 0.446 | 1 | < 0.1% |
| 0.47 | 1 | < 0.1% |
| 0.486 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 124717 | 1 | |
| 89576.36 | 1 | |
| 87438.516 | 2 | |
| 76090 | 1 | |
| 63434 | 1 | |
| 53874 | 2 | |
| 46271 | 1 | |
| 45361 | 1 | |
| 33274 | 1 | |
| 31851.158 | 1 |
onpromotion
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 285 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7271361 |
| Minimum | 0 |
|---|---|
| Maximum | 716 |
| Zeros | 238596 |
| Zeros (%) | 74.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 21 |
| Maximum | 716 |
| Range | 716 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 15.512095 |
|---|---|
| Coefficient of variation (CV) | 4.1619342 |
| Kurtosis | 240.59292 |
| Mean | 3.7271361 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.93287 |
| Sum | 1200313 |
| Variance | 240.62509 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 238596 | |
| 1 | 23351 | 7.3% |
| 2 | 10068 | 3.1% |
| 3 | 5900 | 1.8% |
| 4 | 4381 | 1.4% |
| 5 | 3387 | 1.1% |
| 6 | 3048 | 0.9% |
| 7 | 2557 | 0.8% |
| 8 | 1975 | 0.6% |
| 9 | 1753 | 0.5% |
| Other values (275) | 27031 | 8.4% |
| Value | Count | Frequency (%) |
| 0 | 238596 | |
| 1 | 23351 | 7.3% |
| 2 | 10068 | 3.1% |
| 3 | 5900 | 1.8% |
| 4 | 4381 | 1.4% |
| 5 | 3387 | 1.1% |
| 6 | 3048 | 0.9% |
| 7 | 2557 | 0.8% |
| 8 | 1975 | 0.6% |
| 9 | 1753 | 0.5% |
| Value | Count | Frequency (%) |
| 716 | 1 | |
| 697 | 1 | |
| 672 | 1 | |
| 655 | 1 | |
| 646 | 1 | |
| 644 | 1 | |
| 642 | 1 | |
| 639 | 1 | |
| 633 | 1 | |
| 630 | 2 |
city
Categorical
HIGH CORRELATION
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| Quito | |
|---|---|
| Guayaquil | |
| Santo Domingo | |
| Cuenca | |
| Ambato | |
| Other values (17) |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 6.8639205 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2210505 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Quito |
|---|---|
| 2nd row | Quito |
| 3rd row | Quito |
| 4th row | Quito |
| 5th row | Quito |
Common Values
| Value | Count | Frequency (%) |
| Quito | 112266 | |
| Guayaquil | 47784 | |
| Santo Domingo | 16104 | 5.0% |
| Cuenca | 16005 | 5.0% |
| Ambato | 12804 | 4.0% |
| Machala | 12804 | 4.0% |
| Latacunga | 12606 | 3.9% |
| Quevedo | 6402 | 2.0% |
| Esmeraldas | 6402 | 2.0% |
| Playas | 6402 | 2.0% |
| Other values (12) | 72468 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| quito | 112266 | |
| guayaquil | 47784 | |
| santo | 16104 | 4.7% |
| domingo | 16104 | 4.7% |
| cuenca | 16005 | 4.6% |
| ambato | 12804 | 3.7% |
| machala | 12804 | 3.7% |
| latacunga | 12606 | 3.7% |
| cayambe | 6402 | 1.9% |
| ibarra | 6402 | 1.9% |
| Other values (14) | 85272 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 362010 | |
| u | 258753 | |
| o | 208428 | 9.4% |
| i | 195129 | 8.8% |
| t | 165594 | 7.5% |
| Q | 118668 | 5.4% |
| l | 92598 | 4.2% |
| n | 85602 | 3.9% |
| y | 70092 | 3.2% |
| e | 60654 | 2.7% |
| Other values (24) | 592977 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1843446 | |
| Uppercase Letter | 344553 | 15.6% |
| Space Separator | 22506 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 362010 | |
| u | 258753 | |
| o | 208428 | |
| i | 195129 | |
| t | 165594 | |
| l | 92598 | 5.0% |
| n | 85602 | 4.6% |
| y | 70092 | 3.8% |
| e | 60654 | 3.3% |
| m | 54450 | 3.0% |
| Other values (10) | 290136 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 118668 | |
| G | 54186 | |
| C | 28809 | 8.4% |
| L | 25245 | 7.3% |
| S | 22506 | 6.5% |
| D | 22506 | 6.5% |
| M | 18381 | 5.3% |
| E | 12804 | 3.7% |
| A | 12804 | 3.7% |
| P | 9504 | 2.8% |
| Other values (3) | 19140 | 5.6% |
Space Separator
| Value | Count | Frequency (%) |
| 22506 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2187999 | |
| Common | 22506 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 362010 | |
| u | 258753 | |
| o | 208428 | 9.5% |
| i | 195129 | 8.9% |
| t | 165594 | 7.6% |
| Q | 118668 | 5.4% |
| l | 92598 | 4.2% |
| n | 85602 | 3.9% |
| y | 70092 | 3.2% |
| e | 60654 | 2.8% |
| Other values (23) | 570471 |
Common
| Value | Count | Frequency (%) |
| 22506 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2210505 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 362010 | |
| u | 258753 | |
| o | 208428 | 9.4% |
| i | 195129 | 8.8% |
| t | 165594 | 7.5% |
| Q | 118668 | 5.4% |
| l | 92598 | 4.2% |
| n | 85602 | 3.9% |
| y | 70092 | 3.2% |
| e | 60654 | 2.7% |
| Other values (24) | 592977 |
state
Categorical
HIGH CORRELATION
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| Pichincha | |
|---|---|
| Guayas | |
| Santo Domingo de los Tsachilas | |
| Azuay | |
| El Oro | |
| Other values (11) |
Length
| Max length | 30 |
|---|---|
| Median length | 11 |
| Mean length | 8.8598217 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2853279 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pichincha |
|---|---|
| 2nd row | Pichincha |
| 3rd row | Pichincha |
| 4th row | Pichincha |
| 5th row | Pichincha |
Common Values
| Value | Count | Frequency (%) |
| Pichincha | 118668 | |
| Guayas | 66825 | |
| Santo Domingo de los Tsachilas | 16104 | 5.0% |
| Azuay | 16005 | 5.0% |
| El Oro | 12804 | 4.0% |
| Tungurahua | 12804 | 4.0% |
| Los Rios | 12804 | 4.0% |
| Cotopaxi | 12606 | 3.9% |
| Manabi | 11979 | 3.7% |
| Esmeraldas | 6402 | 2.0% |
| Other values (6) | 35046 | 10.9% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| pichincha | 118668 | |
| guayas | 66825 | |
| los | 28908 | 6.9% |
| santo | 16104 | 3.8% |
| domingo | 16104 | 3.8% |
| de | 16104 | 3.8% |
| tsachilas | 16104 | 3.8% |
| azuay | 16005 | 3.8% |
| tungurahua | 12804 | 3.1% |
| rios | 12804 | 3.1% |
| Other values (12) | 98043 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 452067 | |
| i | 319671 | |
| h | 272580 | 9.6% |
| c | 253440 | 8.9% |
| n | 188463 | 6.6% |
| s | 156651 | 5.5% |
| o | 153516 | 5.4% |
| u | 127644 | 4.5% |
| P | 121770 | 4.3% |
| 96426 | 3.4% | |
| Other values (27) | 711051 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2370588 | |
| Uppercase Letter | 386265 | 13.5% |
| Space Separator | 96426 | 3.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 452067 | |
| i | 319671 | |
| h | 272580 | |
| c | 253440 | |
| n | 188463 | |
| s | 156651 | 6.6% |
| o | 153516 | 6.5% |
| u | 127644 | 5.4% |
| y | 82830 | 3.5% |
| l | 64218 | 2.7% |
| Other values (12) | 299508 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 121770 | |
| G | 66825 | |
| T | 28908 | 7.5% |
| E | 25608 | 6.6% |
| S | 22506 | 5.8% |
| L | 19206 | 5.0% |
| C | 18942 | 4.9% |
| D | 16104 | 4.2% |
| A | 16005 | 4.1% |
| R | 12804 | 3.3% |
| Other values (4) | 37587 | 9.7% |
Space Separator
| Value | Count | Frequency (%) |
| 96426 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2756853 | |
| Common | 96426 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 452067 | |
| i | 319671 | |
| h | 272580 | |
| c | 253440 | |
| n | 188463 | 6.8% |
| s | 156651 | 5.7% |
| o | 153516 | 5.6% |
| u | 127644 | 4.6% |
| P | 121770 | 4.4% |
| y | 82830 | 3.0% |
| Other values (26) | 628221 |
Common
| Value | Count | Frequency (%) |
| 96426 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2853279 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 452067 | |
| i | 319671 | |
| h | 272580 | 9.6% |
| c | 253440 | 8.9% |
| n | 188463 | 6.6% |
| s | 156651 | 5.5% |
| o | 153516 | 5.4% |
| u | 127644 | 4.5% |
| P | 121770 | 4.3% |
| 96426 | 3.4% | |
| Other values (27) | 711051 |
type_of_store
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| D | |
|---|---|
| C | |
| A | |
| B | |
| E |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 322047 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | D |
|---|---|
| 2nd row | D |
| 3rd row | D |
| 4th row | D |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| D | 110121 | |
| C | 92367 | |
| A | 51645 | |
| B | 45144 | |
| E | 22770 | 7.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| d | 110121 | |
| c | 92367 | |
| a | 51645 | |
| b | 45144 | |
| e | 22770 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 110121 | |
| C | 92367 | |
| A | 51645 | |
| B | 45144 | |
| E | 22770 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 322047 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 110121 | |
| C | 92367 | |
| A | 51645 | |
| B | 45144 | |
| E | 22770 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 322047 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 110121 | |
| C | 92367 | |
| A | 51645 | |
| B | 45144 | |
| E | 22770 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 322047 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 110121 | |
| C | 92367 | |
| A | 51645 | |
| B | 45144 | |
| E | 22770 | 7.1% |
cluster
Real number (ℝ)
HIGH CORRELATION
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.531202 |
| Minimum | 1 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 9 |
| Q3 | 13 |
| 95-th percentile | 15 |
| Maximum | 17 |
| Range | 16 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 4.7138089 |
|---|---|
| Coefficient of variation (CV) | 0.55253748 |
| Kurtosis | -1.2955902 |
| Mean | 8.531202 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.033899842 |
| Sum | 2747448 |
| Variance | 22.219994 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 3 | 44715 | |
| 10 | 35574 | |
| 6 | 32736 | |
| 15 | 31812 | |
| 14 | 25608 | |
| 13 | 24354 | |
| 4 | 19206 | 6.0% |
| 8 | 19206 | 6.0% |
| 1 | 18546 | 5.8% |
| 11 | 13233 | 4.1% |
| Other values (7) | 57057 |
| Value | Count | Frequency (%) |
| 1 | 18546 | |
| 2 | 9603 | 3.0% |
| 3 | 44715 | |
| 4 | 19206 | |
| 5 | 6402 | 2.0% |
| 6 | 32736 | |
| 7 | 9438 | 2.9% |
| 8 | 19206 | |
| 9 | 12804 | 4.0% |
| 10 | 35574 |
| Value | Count | Frequency (%) |
| 17 | 6402 | 2.0% |
| 16 | 6006 | 1.9% |
| 15 | 31812 | |
| 14 | 25608 | |
| 13 | 24354 | |
| 12 | 6402 | 2.0% |
| 11 | 13233 | 4.1% |
| 10 | 35574 | |
| 9 | 12804 | 4.0% |
| 8 | 19206 |
transactions
Real number (ℝ)
| Distinct | 3097 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1734.1178 |
| Minimum | 54 |
|---|---|
| Maximum | 8359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 54 |
|---|---|
| 5-th percentile | 642 |
| Q1 | 1030 |
| median | 1409 |
| Q3 | 2148 |
| 95-th percentile | 3788 |
| Maximum | 8359 |
| Range | 8305 |
| Interquartile range (IQR) | 1118 |
Descriptive statistics
| Standard deviation | 1050.335 |
|---|---|
| Coefficient of variation (CV) | 0.60568838 |
| Kurtosis | 4.8491261 |
| Mean | 1734.1178 |
| Median Absolute Deviation (MAD) | 483 |
| Skewness | 1.8467475 |
| Sum | 5.5846745 × 108 |
| Variance | 1103203.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1304 | 561 | 0.2% |
| 1248 | 495 | 0.2% |
| 1296 | 495 | 0.2% |
| 1147 | 462 | 0.1% |
| 1451 | 462 | 0.1% |
| 1392 | 462 | 0.1% |
| 1370 | 462 | 0.1% |
| 875 | 462 | 0.1% |
| 984 | 429 | 0.1% |
| 1283 | 429 | 0.1% |
| Other values (3087) | 317328 |
| Value | Count | Frequency (%) |
| 54 | 33 | |
| 353 | 33 | |
| 357 | 33 | |
| 381 | 33 | |
| 383 | 33 | |
| 386 | 33 | |
| 396 | 33 | |
| 400 | 66 | |
| 401 | 33 | |
| 406 | 33 |
| Value | Count | Frequency (%) |
| 8359 | 33 | |
| 8307 | 33 | |
| 8256 | 33 | |
| 8120 | 33 | |
| 8001 | 33 | |
| 7840 | 33 | |
| 7727 | 33 | |
| 7700 | 33 | |
| 7689 | 33 | |
| 7597 | 33 |
type_of_holiday
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| Holiday | |
|---|---|
| Event | |
| Additional | |
| Transfer | 13695 |
| Bridge | 4884 |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.0452915 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2268915 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Holiday |
|---|---|
| 2nd row | Holiday |
| 3rd row | Holiday |
| 4th row | Holiday |
| 5th row | Holiday |
Common Values
| Value | Count | Frequency (%) |
| Holiday | 202818 | |
| Event | 59235 | 18.4% |
| Additional | 41415 | 12.9% |
| Transfer | 13695 | 4.3% |
| Bridge | 4884 | 1.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| holiday | 202818 | |
| event | 59235 | 18.4% |
| additional | 41415 | 12.9% |
| transfer | 13695 | 4.3% |
| bridge | 4884 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 290532 | |
| d | 290532 | |
| a | 257928 | |
| o | 244233 | |
| l | 244233 | |
| H | 202818 | |
| y | 202818 | |
| n | 114345 | 5.0% |
| t | 100650 | 4.4% |
| e | 77814 | 3.4% |
| Other values (9) | 243012 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1946868 | |
| Uppercase Letter | 322047 | 14.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 290532 | |
| d | 290532 | |
| a | 257928 | |
| o | 244233 | |
| l | 244233 | |
| y | 202818 | |
| n | 114345 | 5.9% |
| t | 100650 | 5.2% |
| e | 77814 | 4.0% |
| v | 59235 | 3.0% |
| Other values (4) | 64548 | 3.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 202818 | |
| E | 59235 | 18.4% |
| A | 41415 | 12.9% |
| T | 13695 | 4.3% |
| B | 4884 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2268915 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 290532 | |
| d | 290532 | |
| a | 257928 | |
| o | 244233 | |
| l | 244233 | |
| H | 202818 | |
| y | 202818 | |
| n | 114345 | 5.0% |
| t | 100650 | 4.4% |
| e | 77814 | 3.4% |
| Other values (9) | 243012 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2268915 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 290532 | |
| d | 290532 | |
| a | 257928 | |
| o | 244233 | |
| l | 244233 | |
| H | 202818 | |
| y | 202818 | |
| n | 114345 | 5.0% |
| t | 100650 | 4.4% |
| e | 77814 | 3.4% |
| Other values (9) | 243012 |
locale
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| National | |
|---|---|
| Local | |
| Regional |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.6919766 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2155131 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | National |
|---|---|
| 2nd row | National |
| 3rd row | National |
| 4th row | National |
| 5th row | National |
Common Values
| Value | Count | Frequency (%) |
| National | 160710 | |
| Local | 140415 | |
| Regional | 20922 | 6.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| national | 160710 | |
| local | 140415 | |
| regional | 20922 | 6.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 482757 | |
| o | 322047 | |
| l | 322047 | |
| i | 181632 | 8.4% |
| n | 181632 | 8.4% |
| N | 160710 | 7.5% |
| t | 160710 | 7.5% |
| L | 140415 | 6.5% |
| c | 140415 | 6.5% |
| R | 20922 | 1.0% |
| Other values (2) | 41844 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1833084 | |
| Uppercase Letter | 322047 | 14.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 482757 | |
| o | 322047 | |
| l | 322047 | |
| i | 181632 | 9.9% |
| n | 181632 | 9.9% |
| t | 160710 | 8.8% |
| c | 140415 | 7.7% |
| e | 20922 | 1.1% |
| g | 20922 | 1.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 160710 | |
| L | 140415 | |
| R | 20922 | 6.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2155131 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 482757 | |
| o | 322047 | |
| l | 322047 | |
| i | 181632 | 8.4% |
| n | 181632 | 8.4% |
| N | 160710 | 7.5% |
| t | 160710 | 7.5% |
| L | 140415 | 6.5% |
| c | 140415 | 6.5% |
| R | 20922 | 1.0% |
| Other values (2) | 41844 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2155131 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 482757 | |
| o | 322047 | |
| l | 322047 | |
| i | 181632 | 8.4% |
| n | 181632 | 8.4% |
| N | 160710 | 7.5% |
| t | 160710 | 7.5% |
| L | 140415 | 6.5% |
| c | 140415 | 6.5% |
| R | 20922 | 1.0% |
| Other values (2) | 41844 | 1.9% |
locale_name
Categorical
HIGH CORRELATION
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| Ecuador | |
|---|---|
| Riobamba | 13266 |
| Guayaquil | 13200 |
| Guaranda | 11781 |
| Latacunga | 11352 |
| Other values (19) |
Length
| Max length | 30 |
|---|---|
| Median length | 7 |
| Mean length | 7.6685111 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2469621 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ecuador |
|---|---|
| 2nd row | Ecuador |
| 3rd row | Ecuador |
| 4th row | Ecuador |
| 5th row | Ecuador |
Common Values
| Value | Count | Frequency (%) |
| Ecuador | 160710 | |
| Riobamba | 13266 | 4.1% |
| Guayaquil | 13200 | 4.1% |
| Guaranda | 11781 | 3.7% |
| Latacunga | 11352 | 3.5% |
| Ambato | 8283 | 2.6% |
| Quito | 8184 | 2.5% |
| Cuenca | 6765 | 2.1% |
| Puyo | 6666 | 2.1% |
| Libertad | 6633 | 2.1% |
| Other values (14) | 75207 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ecuador | 160710 | |
| riobamba | 13266 | 3.7% |
| guayaquil | 13200 | 3.7% |
| guaranda | 11781 | 3.3% |
| domingo | 11418 | 3.2% |
| santo | 11418 | 3.2% |
| latacunga | 11352 | 3.2% |
| ambato | 8283 | 2.3% |
| quito | 8184 | 2.3% |
| cuenca | 6765 | 1.9% |
| Other values (19) | 103125 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 431970 | |
| o | 260733 | |
| u | 243144 | |
| r | 203742 | 8.2% |
| d | 197076 | 8.0% |
| c | 188463 | 7.6% |
| E | 178629 | 7.2% |
| n | 79167 | 3.2% |
| i | 69102 | 2.8% |
| t | 62271 | 2.5% |
| Other values (26) | 555324 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2082432 | |
| Uppercase Letter | 349734 | 14.2% |
| Space Separator | 37455 | 1.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 431970 | |
| o | 260733 | |
| u | 243144 | |
| r | 203742 | |
| d | 197076 | |
| c | 188463 | |
| n | 79167 | 3.8% |
| i | 69102 | 3.3% |
| t | 62271 | 3.0% |
| b | 59070 | 2.8% |
| Other values (12) | 287694 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 178629 | |
| G | 24981 | 7.1% |
| C | 24453 | 7.0% |
| L | 23067 | 6.6% |
| S | 21351 | 6.1% |
| Q | 14718 | 4.2% |
| R | 13266 | 3.8% |
| D | 11418 | 3.3% |
| M | 9867 | 2.8% |
| A | 8283 | 2.4% |
| Other values (3) | 19701 | 5.6% |
Space Separator
| Value | Count | Frequency (%) |
| 37455 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2432166 | |
| Common | 37455 | 1.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 431970 | |
| o | 260733 | |
| u | 243144 | |
| r | 203742 | 8.4% |
| d | 197076 | 8.1% |
| c | 188463 | 7.7% |
| E | 178629 | 7.3% |
| n | 79167 | 3.3% |
| i | 69102 | 2.8% |
| t | 62271 | 2.6% |
| Other values (25) | 517869 |
Common
| Value | Count | Frequency (%) |
| 37455 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2469621 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 431970 | |
| o | 260733 | |
| u | 243144 | |
| r | 203742 | 8.2% |
| d | 197076 | 8.0% |
| c | 188463 | 7.6% |
| E | 178629 | 7.2% |
| n | 79167 | 3.2% |
| i | 69102 | 2.8% |
| t | 62271 | 2.5% |
| Other values (26) | 555324 |
description
Text
| Distinct | 80 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 34 |
| Mean length | 21.204837 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6828954 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Carnaval |
|---|---|
| 2nd row | Carnaval |
| 3rd row | Carnaval |
| 4th row | Carnaval |
| 5th row | Carnaval |
| Value | Count | Frequency (%) |
| de | 202488 | |
| fundacion | 69564 | 7.6% |
| cantonizacion | 54318 | 6.0% |
| independencia | 38346 | 4.2% |
| terremoto | 36729 | 4.0% |
| del | 21450 | 2.4% |
| provincializacion | 20922 | 2.3% |
| dia | 19965 | 2.2% |
| santo | 19569 | 2.1% |
| primer | 17094 | 1.9% |
| Other values (78) | 410850 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 887568 | |
| n | 671022 | 9.8% |
| 589248 | 8.6% | |
| i | 555951 | 8.1% |
| e | 521004 | 7.6% |
| d | 502260 | 7.4% |
| o | 465762 | 6.8% |
| c | 263571 | 3.9% |
| r | 255057 | 3.7% |
| u | 217272 | 3.2% |
| Other values (48) | 1900239 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5382069 | |
| Uppercase Letter | 661353 | 9.7% |
| Space Separator | 589248 | 8.6% |
| Decimal Number | 104280 | 1.5% |
| Math Symbol | 41613 | 0.6% |
| Dash Punctuation | 39534 | 0.6% |
| Other Punctuation | 10857 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 887568 | |
| n | 671022 | |
| i | 555951 | |
| e | 521004 | |
| d | 502260 | |
| o | 465762 | |
| c | 263571 | 4.9% |
| r | 255057 | 4.7% |
| u | 217272 | 4.0% |
| t | 205953 | 3.8% |
| Other values (15) | 836649 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 106788 | |
| F | 80817 | |
| M | 64053 | |
| P | 58179 | |
| T | 55110 | |
| I | 48048 | |
| G | 41745 | 6.3% |
| S | 32604 | 4.9% |
| D | 28215 | 4.3% |
| N | 26565 | 4.0% |
| Other values (9) | 119229 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 41844 | |
| 2 | 20625 | |
| 3 | 12078 | 11.6% |
| 4 | 6996 | 6.7% |
| 6 | 5247 | 5.0% |
| 0 | 5247 | 5.0% |
| 7 | 3498 | 3.4% |
| 5 | 3498 | 3.4% |
| 9 | 3498 | 3.4% |
| 8 | 1749 | 1.7% |
Space Separator
| Value | Count | Frequency (%) |
| 589248 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 41613 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 39534 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 10857 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6043422 | |
| Common | 785532 | 11.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 887568 | |
| n | 671022 | |
| i | 555951 | 9.2% |
| e | 521004 | 8.6% |
| d | 502260 | 8.3% |
| o | 465762 | 7.7% |
| c | 263571 | 4.4% |
| r | 255057 | 4.2% |
| u | 217272 | 3.6% |
| t | 205953 | 3.4% |
| Other values (34) | 1498002 |
Common
| Value | Count | Frequency (%) |
| 589248 | ||
| 1 | 41844 | 5.3% |
| + | 41613 | 5.3% |
| - | 39534 | 5.0% |
| 2 | 20625 | 2.6% |
| 3 | 12078 | 1.5% |
| : | 10857 | 1.4% |
| 4 | 6996 | 0.9% |
| 6 | 5247 | 0.7% |
| 0 | 5247 | 0.7% |
| Other values (4) | 12243 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6828954 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 887568 | |
| n | 671022 | 9.8% |
| 589248 | 8.6% | |
| i | 555951 | 8.1% |
| e | 521004 | 7.6% |
| d | 502260 | 7.4% |
| o | 465762 | 6.8% |
| c | 263571 | 3.9% |
| r | 255057 | 3.7% |
| u | 217272 | 3.2% |
| Other values (48) | 1900239 |
transferred
Boolean
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| False | |
|---|---|
| True | 13695 |
| Value | Count | Frequency (%) |
| False | 308352 | |
| True | 13695 | 4.3% |
dcoilwtico
Real number (ℝ)
HIGH CORRELATION
| Distinct | 171 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.686222 |
| Minimum | 27.96 |
|---|---|
| Maximum | 107.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 27.96 |
|---|---|
| 5-th percentile | 37.46 |
| Q1 | 44.88 |
| median | 51.98 |
| Q3 | 94.09 |
| 95-th percentile | 106.07 |
| Maximum | 107.95 |
| Range | 79.99 |
| Interquartile range (IQR) | 49.21 |
Descriptive statistics
| Standard deviation | 24.842082 |
|---|---|
| Coefficient of variation (CV) | 0.39006996 |
| Kurtosis | -1.1593673 |
| Mean | 63.686222 |
| Median Absolute Deviation (MAD) | 9.03 |
| Skewness | 0.71614784 |
| Sum | 20509957 |
| Variance | 617.12903 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 107.04 | 6204 | 1.9% |
| 53.19 | 5247 | 1.6% |
| 59.59 | 4950 | 1.5% |
| 104.76 | 4653 | 1.4% |
| 95.25 | 4653 | 1.4% |
| 46.02 | 3564 | 1.1% |
| 46.21 | 3531 | 1.1% |
| 36.12 | 3498 | 1.1% |
| 43.18 | 3498 | 1.1% |
| 51.98 | 3498 | 1.1% |
| Other values (161) | 278751 |
| Value | Count | Frequency (%) |
| 27.96 | 1749 | |
| 29.71 | 1749 | |
| 34.55 | 1749 | |
| 34.57 | 1749 | |
| 35.36 | 1749 | |
| 36.12 | 3498 | |
| 36.76 | 1749 | |
| 37.13 | 1749 | |
| 37.46 | 1749 | |
| 37.62 | 1749 |
| Value | Count | Frequency (%) |
| 107.95 | 1551 | 0.5% |
| 107.43 | 1551 | 0.5% |
| 107.2 | 1551 | 0.5% |
| 107.13 | 1518 | 0.5% |
| 107.04 | 6204 | |
| 106.83 | 1551 | 0.5% |
| 106.61 | 1551 | 0.5% |
| 106.07 | 1551 | 0.5% |
| 106.06 | 1551 | 0.5% |
| 105.47 | 1518 | 0.5% |
year
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| 2016 | |
|---|---|
| 2014 | |
| 2015 | |
| 2013 | |
| 2017 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1288188 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2013 |
|---|---|
| 2nd row | 2013 |
| 3rd row | 2013 |
| 4th row | 2013 |
| 5th row | 2013 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 99198 | |
| 2014 | 73524 | |
| 2015 | 65901 | |
| 2013 | 46266 | |
| 2017 | 37158 | 11.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 99198 | |
| 2014 | 73524 | |
| 2015 | 65901 | |
| 2013 | 46266 | |
| 2017 | 37158 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 322047 | |
| 0 | 322047 | |
| 1 | 322047 | |
| 6 | 99198 | 7.7% |
| 4 | 73524 | 5.7% |
| 5 | 65901 | 5.1% |
| 3 | 46266 | 3.6% |
| 7 | 37158 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1288188 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 322047 | |
| 0 | 322047 | |
| 1 | 322047 | |
| 6 | 99198 | 7.7% |
| 4 | 73524 | 5.7% |
| 5 | 65901 | 5.1% |
| 3 | 46266 | 3.6% |
| 7 | 37158 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1288188 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 322047 | |
| 0 | 322047 | |
| 1 | 322047 | |
| 6 | 99198 | 7.7% |
| 4 | 73524 | 5.7% |
| 5 | 65901 | 5.1% |
| 3 | 46266 | 3.6% |
| 7 | 37158 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1288188 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 322047 | |
| 0 | 322047 | |
| 1 | 322047 | |
| 6 | 99198 | 7.7% |
| 4 | 73524 | 5.7% |
| 5 | 65901 | 5.1% |
| 3 | 46266 | 3.6% |
| 7 | 37158 | 2.9% |
month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.3894866 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 7 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2425734 |
|---|---|
| Coefficient of variation (CV) | 0.43880902 |
| Kurtosis | -1.3056153 |
| Mean | 7.3894866 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.092296768 |
| Sum | 2379762 |
| Variance | 10.514282 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 12 | 51381 | |
| 4 | 50391 | |
| 11 | 45012 | |
| 5 | 40953 | |
| 7 | 37191 | |
| 6 | 27192 | |
| 8 | 25278 | |
| 10 | 14553 | 4.5% |
| 2 | 13266 | 4.1% |
| 3 | 9966 | 3.1% |
| Other values (2) | 6864 | 2.1% |
| Value | Count | Frequency (%) |
| 1 | 3465 | 1.1% |
| 2 | 13266 | 4.1% |
| 3 | 9966 | 3.1% |
| 4 | 50391 | |
| 5 | 40953 | |
| 6 | 27192 | |
| 7 | 37191 | |
| 8 | 25278 | |
| 9 | 3399 | 1.1% |
| 10 | 14553 | 4.5% |
| Value | Count | Frequency (%) |
| 12 | 51381 | |
| 11 | 45012 | |
| 10 | 14553 | 4.5% |
| 9 | 3399 | 1.1% |
| 8 | 25278 | |
| 7 | 37191 | |
| 6 | 27192 | |
| 5 | 40953 | |
| 4 | 50391 | |
| 3 | 9966 | 3.1% |
day
Real number (ℝ)
HIGH CORRELATION
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.711548 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 12 |
| Q3 | 24 |
| 95-th percentile | 28 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 9.1952195 |
|---|---|
| Coefficient of variation (CV) | 0.62503411 |
| Kurtosis | -1.4367679 |
| Mean | 14.711548 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.051555478 |
| Sum | 4737810 |
| Variance | 84.552062 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 25 | 27654 | 8.6% |
| 12 | 23133 | 7.2% |
| 3 | 23034 | 7.2% |
| 24 | 19932 | 6.2% |
| 23 | 18084 | 5.6% |
| 1 | 16137 | 5.0% |
| 2 | 13662 | 4.2% |
| 10 | 13596 | 4.2% |
| 11 | 13200 | 4.1% |
| 5 | 13167 | 4.1% |
| Other values (21) | 140448 |
| Value | Count | Frequency (%) |
| 1 | 16137 | |
| 2 | 13662 | |
| 3 | 23034 | |
| 4 | 6567 | 2.0% |
| 5 | 13167 | |
| 6 | 9933 | |
| 7 | 11385 | |
| 8 | 8382 | 2.6% |
| 9 | 9933 | |
| 10 | 13596 |
| Value | Count | Frequency (%) |
| 31 | 4884 | 1.5% |
| 30 | 3300 | 1.0% |
| 29 | 3267 | 1.0% |
| 28 | 10197 | 3.2% |
| 27 | 6996 | 2.2% |
| 26 | 9999 | 3.1% |
| 25 | 27654 | |
| 24 | 19932 | |
| 23 | 18084 | |
| 22 | 11913 |
day_of_week
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.9 MiB |
| 4 | |
|---|---|
| 0 | |
| 1 | |
| 3 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 322047 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 322047 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 322047 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 322047 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 75207 | |
| 0 | 74580 | |
| 1 | 61050 | |
| 3 | 58476 | |
| 2 | 52734 |
| city | cluster | day | day_of_week | dcoilwtico | family | id | locale | locale_name | month | onpromotion | sales | state | store_nbr | transactions | transferred | type_of_holiday | type_of_store | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| city | 1.000 | 0.080 | -0.001 | 0.001 | -0.001 | 0.000 | 0.000 | 0.016 | 0.005 | -0.004 | 0.017 | 0.047 | 1.000 | -0.355 | 0.198 | 0.011 | 0.013 | 0.642 | 0.060 |
| cluster | 0.080 | 1.000 | 0.001 | 0.000 | 0.022 | 0.000 | -0.020 | 0.009 | 0.004 | 0.001 | -0.004 | 0.025 | 0.515 | -0.071 | 0.219 | 0.005 | 0.007 | 0.755 | 0.039 |
| day | -0.001 | 0.001 | 1.000 | 0.167 | -0.032 | 0.000 | 0.055 | 0.401 | 0.593 | 0.056 | 0.019 | -0.000 | 0.007 | 0.001 | 0.034 | 0.316 | 0.314 | 0.000 | 0.198 |
| day_of_week | 0.001 | 0.000 | 0.167 | 1.000 | -0.009 | 0.000 | 0.100 | 0.118 | 0.232 | 0.023 | 0.099 | 0.019 | 0.000 | 0.002 | -0.025 | 0.212 | 0.183 | 0.000 | 0.104 |
| dcoilwtico | -0.001 | 0.022 | -0.032 | -0.009 | 1.000 | 0.000 | -0.689 | 0.275 | 0.334 | 0.021 | -0.220 | -0.117 | 0.032 | -0.008 | 0.011 | 0.167 | 0.262 | 0.020 | 0.577 |
| family | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | -0.091 | -0.058 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| id | 0.000 | -0.020 | 0.055 | 0.100 | -0.689 | 0.000 | 1.000 | 0.294 | 0.322 | -0.057 | 0.367 | 0.141 | 0.040 | 0.016 | -0.024 | 0.261 | 0.376 | 0.023 | 0.906 |
| locale | 0.016 | 0.009 | 0.401 | 0.118 | 0.275 | 0.000 | 0.294 | 1.000 | 1.000 | -0.080 | 0.006 | 0.017 | 0.016 | -0.001 | 0.049 | 0.108 | 0.439 | 0.004 | 0.183 |
| locale_name | 0.005 | 0.004 | 0.593 | 0.232 | 0.334 | 0.000 | 0.322 | 1.000 | 1.000 | 0.176 | -0.013 | -0.022 | 0.007 | 0.001 | -0.032 | 0.239 | 0.378 | 0.000 | 0.266 |
| month | -0.004 | 0.001 | 0.056 | 0.023 | 0.021 | 0.000 | -0.057 | -0.080 | 0.176 | 1.000 | -0.011 | 0.034 | 0.014 | 0.001 | 0.127 | 0.281 | 0.351 | 0.007 | 0.281 |
| onpromotion | 0.017 | -0.004 | 0.019 | 0.099 | -0.220 | -0.091 | 0.367 | 0.006 | -0.013 | -0.011 | 1.000 | 0.581 | 0.022 | 0.035 | 0.056 | 0.024 | 0.014 | 0.024 | 0.042 |
| sales | 0.047 | 0.025 | -0.000 | 0.019 | -0.117 | -0.058 | 0.141 | 0.017 | -0.022 | 0.034 | 0.581 | 1.000 | 0.012 | 0.030 | 0.182 | 0.002 | 0.008 | 0.028 | 0.006 |
| state | 1.000 | 0.515 | 0.007 | 0.000 | 0.032 | 0.000 | 0.040 | 0.016 | 0.007 | 0.014 | 0.022 | 0.012 | 1.000 | -0.235 | 0.318 | 0.011 | 0.013 | 0.519 | 0.054 |
| store_nbr | -0.355 | -0.071 | 0.001 | 0.002 | -0.008 | 0.000 | 0.016 | -0.001 | 0.001 | 0.001 | 0.035 | 0.030 | -0.235 | 1.000 | 0.054 | 0.007 | 0.009 | 0.670 | 0.043 |
| transactions | 0.198 | 0.219 | 0.034 | -0.025 | 0.011 | 0.000 | -0.024 | 0.049 | -0.032 | 0.127 | 0.056 | 0.182 | 0.318 | 0.054 | 1.000 | 0.048 | 0.143 | 0.415 | 0.046 |
| transferred | 0.011 | 0.005 | 0.316 | 0.212 | 0.167 | 0.000 | 0.261 | 0.108 | 0.239 | 0.281 | 0.024 | 0.002 | 0.011 | 0.007 | 0.048 | 1.000 | 0.162 | 0.000 | 0.203 |
| type_of_holiday | 0.013 | 0.007 | 0.314 | 0.183 | 0.262 | 0.000 | 0.376 | 0.439 | 0.378 | 0.351 | 0.014 | 0.008 | 0.013 | 0.009 | 0.143 | 0.162 | 1.000 | 0.003 | 0.258 |
| type_of_store | 0.642 | 0.755 | 0.000 | 0.000 | 0.020 | 0.000 | 0.023 | 0.004 | 0.000 | 0.007 | 0.024 | 0.028 | 0.519 | 0.670 | 0.415 | 0.000 | 0.003 | 1.000 | 0.022 |
| year | 0.060 | 0.039 | 0.198 | 0.104 | 0.577 | 0.000 | 0.906 | 0.183 | 0.266 | 0.281 | 0.042 | 0.006 | 0.054 | 0.043 | 0.046 | 0.203 | 0.258 | 0.022 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| id | date | store_nbr | family | sales | onpromotion | city | state | type_of_store | cluster | transactions | type_of_holiday | locale | locale_name | description | transferred | dcoilwtico | year | month | day | day_of_week | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 73062.0 | 2013-02-11 | 1.0 | AUTOMOTIVE | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 1 | 73085.0 | 2013-02-11 | 1.0 | MAGAZINES | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 2 | 73084.0 | 2013-02-11 | 1.0 | LIQUOR,WINE,BEER | 21.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 3 | 73083.0 | 2013-02-11 | 1.0 | LINGERIE | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 4 | 73082.0 | 2013-02-11 | 1.0 | LAWN AND GARDEN | 3.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 5 | 73081.0 | 2013-02-11 | 1.0 | LADIESWEAR | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 6 | 73080.0 | 2013-02-11 | 1.0 | HOME CARE | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 7 | 73079.0 | 2013-02-11 | 1.0 | HOME APPLIANCES | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 8 | 73078.0 | 2013-02-11 | 1.0 | HOME AND KITCHEN II | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| 9 | 73077.0 | 2013-02-11 | 1.0 | HOME AND KITCHEN I | 0.0 | 0.0 | Quito | Pichincha | D | 13 | 396 | Holiday | National | Ecuador | Carnaval | False | 97.01 | 2013 | 2 | 11 | 0 |
| id | date | store_nbr | family | sales | onpromotion | city | state | type_of_store | cluster | transactions | type_of_holiday | locale | locale_name | description | transferred | dcoilwtico | year | month | day | day_of_week | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322037 | 1297880.0 | 2015-01-01 | 25.0 | MAGAZINES | 0.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322038 | 1297882.0 | 2015-01-01 | 25.0 | PERSONAL CARE | 203.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322039 | 1297881.0 | 2015-01-01 | 25.0 | MEATS | 479.76700 | 2.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322040 | 1297883.0 | 2015-01-01 | 25.0 | PET SUPPLIES | 0.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322041 | 1297889.0 | 2015-01-01 | 25.0 | SEAFOOD | 14.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322042 | 1297888.0 | 2015-01-01 | 25.0 | SCHOOL AND OFFICE SUPPLIES | 0.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322043 | 1297887.0 | 2015-01-01 | 25.0 | PRODUCE | 105.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322044 | 1297886.0 | 2015-01-01 | 25.0 | PREPARED FOODS | 121.94100 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322045 | 1297885.0 | 2015-01-01 | 25.0 | POULTRY | 279.16998 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |
| 322046 | 1297884.0 | 2015-01-01 | 25.0 | PLAYERS AND ELECTRONICS | 0.00000 | 0.0 | Salinas | Santa Elena | D | 1 | 2202 | Holiday | National | Ecuador | Primer dia del ano | False | 53.45 | 2015 | 1 | 1 | 3 |